﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="BizDataDataSet" targetNamespace="http://tempuri.org/BizDataDataSet.xsd" xmlns:mstns="http://tempuri.org/BizDataDataSet.xsd" xmlns="http://tempuri.org/BizDataDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="dnbTestConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="dnbTestConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.DnBDataCollector.My.MySettings.GlobalReference.Default.dnbTestConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="bizDataTableAdapter" GeneratorDataComponentClassName="bizDataTableAdapter" Name="bizData" UserDataComponentName="bizDataTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="dnbTestConnectionString (MySettings)" DbObjectName="BizName.dbo.bizData" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="GetData">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [bizData] WHERE (([bizDataId] = @Original_bizDataId) AND ([CompanyId] = @Original_CompanyId) AND ([CompanyName] = @Original_CompanyName) AND ((@IsNull_Address1 = 1 AND [Address1] IS NULL) OR ([Address1] = @Original_Address1)) AND ((@IsNull_City = 1 AND [City] IS NULL) OR ([City] = @Original_City)) AND ((@IsNull_StateOrProvince = 1 AND [StateOrProvince] IS NULL) OR ([StateOrProvince] = @Original_StateOrProvince)) AND ((@IsNull_PostalCode = 1 AND [PostalCode] IS NULL) OR ([PostalCode] = @Original_PostalCode)) AND ((@IsNull_Phone = 1 AND [Phone] IS NULL) OR ([Phone] = @Original_Phone)) AND ((@IsNull_offset = 1 AND [offset] IS NULL) OR ([offset] = @Original_offset)) AND ((@IsNull_LocationType = 1 AND [LocationType] IS NULL) OR ([LocationType] = @Original_LocationType)) AND ((@IsNull_Duns = 1 AND [Duns] IS NULL) OR ([Duns] = @Original_Duns)) AND ((@IsNull_ParentDuns = 1 AND [ParentDuns] IS NULL) OR ([ParentDuns] = @Original_ParentDuns)) AND ((@IsNull_UltimateParentDuns = 1 AND [UltimateParentDuns] IS NULL) OR ([UltimateParentDuns] = @Original_UltimateParentDuns)) AND ((@IsNull_Sales = 1 AND [Sales] IS NULL) OR ([Sales] = @Original_Sales)) AND ((@IsNull_DBA = 1 AND [DBA] IS NULL) OR ([DBA] = @Original_DBA)) AND ((@IsNull_CountryID = 1 AND [CountryID] IS NULL) OR ([CountryID] = @Original_CountryID)) AND ((@IsNull_primaryURLs = 1 AND [primaryURLs] IS NULL) OR ([primaryURLs] = @Original_primaryURLs)) AND ((@IsNull_Description = 1 AND [Description] IS NULL) OR ([Description] = @Original_Description)) AND ((@IsNull_CompanyType = 1 AND [CompanyType] IS NULL) OR ([CompanyType] = @Original_CompanyType)) AND ((@IsNull_IndustryName = 1 AND [IndustryName] IS NULL) OR ([IndustryName] = @Original_IndustryName)) AND ((@IsNull_IndustryDescription = 1 AND [IndustryDescription] IS NULL) OR ([IndustryDescription] = @Original_IndustryDescription)) AND ((@IsNull_lineOfBusiness = 1 AND [lineOfBusiness] IS NULL) OR ([lineOfBusiness] = @Original_lineOfBusiness)) AND ((@IsNull_primaryDnBIC = 1 AND [primaryDnBIC] IS NULL) OR ([primaryDnBIC] = @Original_primaryDnBIC)) AND ((@IsNull_primaryNAICS = 1 AND [primaryNAICS] IS NULL) OR ([primaryNAICS] = @Original_primaryNAICS)) AND ((@IsNull_primaryUSSIC = 1 AND [primaryUSSIC] IS NULL) OR ([primaryUSSIC] = @Original_primaryUSSIC)) AND ((@IsNull_naicsCodes = 1 AND [naicsCodes] IS NULL) OR ([naicsCodes] = @Original_naicsCodes)) AND ((@IsNull_Longitude = 1 AND [Longitude] IS NULL) OR ([Longitude] = @Original_Longitude)) AND ((@IsNull_Latitutude = 1 AND [Latitutude] IS NULL) OR ([Latitutude] = @Original_Latitutude)) AND ((@IsNull_WomenOwned = 1 AND [WomenOwned] IS NULL) OR ([WomenOwned] = @Original_WomenOwned)) AND ((@IsNull_MinorityOwned = 1 AND [MinorityOwned] IS NULL) OR ([MinorityOwned] = @Original_MinorityOwned)) AND ((@IsNull_ownedOrLeased = 1 AND [ownedOrLeased] IS NULL) OR ([ownedOrLeased] = @Original_ownedOrLeased)) AND ((@IsNull_dnbIndustryCode = 1 AND [dnbIndustryCode] IS NULL) OR ([dnbIndustryCode] = @Original_dnbIndustryCode)) AND ((@IsNull_RelatedIndustries = 1 AND [RelatedIndustries] IS NULL) OR ([RelatedIndustries] = @Original_RelatedIndustries)) AND ((@IsNull_fastFacts = 1 AND [fastFacts] IS NULL) OR ([fastFacts] = @Original_fastFacts)) AND ((@IsNull_CompanyKeyWord = 1 AND [CompanyKeyWord] IS NULL) OR ([CompanyKeyWord] = @Original_CompanyKeyWord)) AND ((@IsNull_LastUpdated = 1 AND [LastUpdated] IS NULL) OR ([LastUpdated] = @Original_LastUpdated)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_bizDataId" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="bizDataId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CompanyId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CompanyId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CompanyName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CompanyName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Address1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Address1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Address1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Address1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_City" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_City" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StateOrProvince" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StateOrProvince" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_StateOrProvince" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="StateOrProvince" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PostalCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PostalCode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PostalCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PostalCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Phone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Phone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_offset" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="offset" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_offset" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="offset" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LocationType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LocationType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_LocationType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="LocationType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Duns" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Duns" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Duns" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Duns" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ParentDuns" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ParentDuns" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ParentDuns" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ParentDuns" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UltimateParentDuns" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UltimateParentDuns" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UltimateParentDuns" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UltimateParentDuns" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Sales" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Sales" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Sales" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Sales" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DBA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DBA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DBA" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DBA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CountryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountryID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CountryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountryID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_primaryURLs" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="primaryURLs" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_primaryURLs" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="primaryURLs" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Description" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CompanyType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CompanyType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CompanyType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CompanyType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IndustryName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IndustryName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_IndustryName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="IndustryName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IndustryDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IndustryDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_IndustryDescription" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="IndustryDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_lineOfBusiness" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="lineOfBusiness" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_lineOfBusiness" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="lineOfBusiness" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_primaryDnBIC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="primaryDnBIC" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_primaryDnBIC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="primaryDnBIC" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_primaryNAICS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="primaryNAICS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_primaryNAICS" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="primaryNAICS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_primaryUSSIC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="primaryUSSIC" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_primaryUSSIC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="primaryUSSIC" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_naicsCodes" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="naicsCodes" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_naicsCodes" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="naicsCodes" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Longitude" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Longitude" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Longitude" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Longitude" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Latitutude" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Latitutude" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Latitutude" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Latitutude" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_WomenOwned" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WomenOwned" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_WomenOwned" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="WomenOwned" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MinorityOwned" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MinorityOwned" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_MinorityOwned" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="MinorityOwned" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ownedOrLeased" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ownedOrLeased" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ownedOrLeased" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ownedOrLeased" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dnbIndustryCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dnbIndustryCode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_dnbIndustryCode" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="dnbIndustryCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RelatedIndustries" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RelatedIndustries" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_RelatedIndustries" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="RelatedIndustries" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fastFacts" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fastFacts" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_fastFacts" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fastFacts" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CompanyKeyWord" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CompanyKeyWord" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CompanyKeyWord" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CompanyKeyWord" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LastUpdated" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LastUpdated" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_LastUpdated" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LastUpdated" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [bizData] ([CompanyId], [CompanyName], [Address1], [City], [StateOrProvince], [PostalCode], [Phone], [offset], [LocationType], [Duns], [ParentDuns], [UltimateParentDuns], [Sales], [DBA], [CountryID], [primaryURLs], [Description], [CompanyType], [IndustryName], [IndustryDescription], [lineOfBusiness], [primaryDnBIC], [primaryNAICS], [primaryUSSIC], [naicsCodes], [Longitude], [Latitutude], [WomenOwned], [MinorityOwned], [ownedOrLeased], [dnbIndustryCode], [RelatedIndustries], [fastFacts], [CompanyKeyWord], [LastUpdated]) VALUES (@CompanyId, @CompanyName, @Address1, @City, @StateOrProvince, @PostalCode, @Phone, @offset, @LocationType, @Duns, @ParentDuns, @UltimateParentDuns, @Sales, @DBA, @CountryID, @primaryURLs, @Description, @CompanyType, @IndustryName, @IndustryDescription, @lineOfBusiness, @primaryDnBIC, @primaryNAICS, @primaryUSSIC, @naicsCodes, @Longitude, @Latitutude, @WomenOwned, @MinorityOwned, @ownedOrLeased, @dnbIndustryCode, @RelatedIndustries, @fastFacts, @CompanyKeyWord, @LastUpdated);
SELECT bizDataId, CompanyId, CompanyName, Address1, City, StateOrProvince, PostalCode, Phone, offset, LocationType, Duns, ParentDuns, UltimateParentDuns, Sales, DBA, CountryID, primaryURLs, Description, CompanyType, IndustryName, IndustryDescription, lineOfBusiness, primaryDnBIC, primaryNAICS, primaryUSSIC, naicsCodes, Longitude, Latitutude, WomenOwned, MinorityOwned, ownedOrLeased, dnbIndustryCode, RelatedIndustries, fastFacts, CompanyKeyWord, LastUpdated FROM bizData WHERE (bizDataId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CompanyId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CompanyId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CompanyName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CompanyName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Address1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Address1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@City" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@StateOrProvince" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="StateOrProvince" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PostalCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PostalCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@offset" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="offset" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@LocationType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="LocationType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Duns" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Duns" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ParentDuns" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ParentDuns" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UltimateParentDuns" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UltimateParentDuns" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Sales" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Sales" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DBA" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DBA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CountryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountryID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@primaryURLs" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="primaryURLs" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CompanyType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CompanyType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@IndustryName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="IndustryName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@IndustryDescription" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="IndustryDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@lineOfBusiness" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="lineOfBusiness" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@primaryDnBIC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="primaryDnBIC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@primaryNAICS" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="primaryNAICS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@primaryUSSIC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="primaryUSSIC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@naicsCodes" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="naicsCodes" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Longitude" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Longitude" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Latitutude" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Latitutude" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@WomenOwned" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="WomenOwned" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@MinorityOwned" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="MinorityOwned" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ownedOrLeased" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ownedOrLeased" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@dnbIndustryCode" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="dnbIndustryCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@RelatedIndustries" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="RelatedIndustries" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@fastFacts" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fastFacts" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CompanyKeyWord" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CompanyKeyWord" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@LastUpdated" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LastUpdated" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     bizDataId, CompanyId, CompanyName, Address1, City, StateOrProvince, PostalCode, Phone, offset, LocationType, Duns, ParentDuns, 
                      UltimateParentDuns, Sales, DBA, CountryID, primaryURLs, Description, CompanyType, IndustryName, IndustryDescription, lineOfBusiness, 
                      primaryDnBIC, primaryNAICS, primaryUSSIC, naicsCodes, Longitude, Latitutude, WomenOwned, MinorityOwned, ownedOrLeased, dnbIndustryCode, 
                      RelatedIndustries, fastFacts, CompanyKeyWord, LastUpdated
FROM         bizData</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [bizData] SET [CompanyId] = @CompanyId, [CompanyName] = @CompanyName, [Address1] = @Address1, [City] = @City, [StateOrProvince] = @StateOrProvince, [PostalCode] = @PostalCode, [Phone] = @Phone, [offset] = @offset, [LocationType] = @LocationType, [Duns] = @Duns, [ParentDuns] = @ParentDuns, [UltimateParentDuns] = @UltimateParentDuns, [Sales] = @Sales, [DBA] = @DBA, [CountryID] = @CountryID, [primaryURLs] = @primaryURLs, [Description] = @Description, [CompanyType] = @CompanyType, [IndustryName] = @IndustryName, [IndustryDescription] = @IndustryDescription, [lineOfBusiness] = @lineOfBusiness, [primaryDnBIC] = @primaryDnBIC, [primaryNAICS] = @primaryNAICS, [primaryUSSIC] = @primaryUSSIC, [naicsCodes] = @naicsCodes, [Longitude] = @Longitude, [Latitutude] = @Latitutude, [WomenOwned] = @WomenOwned, [MinorityOwned] = @MinorityOwned, [ownedOrLeased] = @ownedOrLeased, [dnbIndustryCode] = @dnbIndustryCode, [RelatedIndustries] = @RelatedIndustries, [fastFacts] = @fastFacts, [CompanyKeyWord] = @CompanyKeyWord, [LastUpdated] = @LastUpdated WHERE (([bizDataId] = @Original_bizDataId) AND ([CompanyId] = @Original_CompanyId) AND ([CompanyName] = @Original_CompanyName) AND ((@IsNull_Address1 = 1 AND [Address1] IS NULL) OR ([Address1] = @Original_Address1)) AND ((@IsNull_City = 1 AND [City] IS NULL) OR ([City] = @Original_City)) AND ((@IsNull_StateOrProvince = 1 AND [StateOrProvince] IS NULL) OR ([StateOrProvince] = @Original_StateOrProvince)) AND ((@IsNull_PostalCode = 1 AND [PostalCode] IS NULL) OR ([PostalCode] = @Original_PostalCode)) AND ((@IsNull_Phone = 1 AND [Phone] IS NULL) OR ([Phone] = @Original_Phone)) AND ((@IsNull_offset = 1 AND [offset] IS NULL) OR ([offset] = @Original_offset)) AND ((@IsNull_LocationType = 1 AND [LocationType] IS NULL) OR ([LocationType] = @Original_LocationType)) AND ((@IsNull_Duns = 1 AND [Duns] IS NULL) OR ([Duns] = @Original_Duns)) AND ((@IsNull_ParentDuns = 1 AND [ParentDuns] IS NULL) OR ([ParentDuns] = @Original_ParentDuns)) AND ((@IsNull_UltimateParentDuns = 1 AND [UltimateParentDuns] IS NULL) OR ([UltimateParentDuns] = @Original_UltimateParentDuns)) AND ((@IsNull_Sales = 1 AND [Sales] IS NULL) OR ([Sales] = @Original_Sales)) AND ((@IsNull_DBA = 1 AND [DBA] IS NULL) OR ([DBA] = @Original_DBA)) AND ((@IsNull_CountryID = 1 AND [CountryID] IS NULL) OR ([CountryID] = @Original_CountryID)) AND ((@IsNull_primaryURLs = 1 AND [primaryURLs] IS NULL) OR ([primaryURLs] = @Original_primaryURLs)) AND ((@IsNull_Description = 1 AND [Description] IS NULL) OR ([Description] = @Original_Description)) AND ((@IsNull_CompanyType = 1 AND [CompanyType] IS NULL) OR ([CompanyType] = @Original_CompanyType)) AND ((@IsNull_IndustryName = 1 AND [IndustryName] IS NULL) OR ([IndustryName] = @Original_IndustryName)) AND ((@IsNull_IndustryDescription = 1 AND [IndustryDescription] IS NULL) OR ([IndustryDescription] = @Original_IndustryDescription)) AND ((@IsNull_lineOfBusiness = 1 AND [lineOfBusiness] IS NULL) OR ([lineOfBusiness] = @Original_lineOfBusiness)) AND ((@IsNull_primaryDnBIC = 1 AND [primaryDnBIC] IS NULL) OR ([primaryDnBIC] = @Original_primaryDnBIC)) AND ((@IsNull_primaryNAICS = 1 AND [primaryNAICS] IS NULL) OR ([primaryNAICS] = @Original_primaryNAICS)) AND ((@IsNull_primaryUSSIC = 1 AND [primaryUSSIC] IS NULL) OR ([primaryUSSIC] = @Original_primaryUSSIC)) AND ((@IsNull_naicsCodes = 1 AND [naicsCodes] IS NULL) OR ([naicsCodes] = @Original_naicsCodes)) AND ((@IsNull_Longitude = 1 AND [Longitude] IS NULL) OR ([Longitude] = @Original_Longitude)) AND ((@IsNull_Latitutude = 1 AND [Latitutude] IS NULL) OR ([Latitutude] = @Original_Latitutude)) AND ((@IsNull_WomenOwned = 1 AND [WomenOwned] IS NULL) OR ([WomenOwned] = @Original_WomenOwned)) AND ((@IsNull_MinorityOwned = 1 AND [MinorityOwned] IS NULL) OR ([MinorityOwned] = @Original_MinorityOwned)) AND ((@IsNull_ownedOrLeased = 1 AND [ownedOrLeased] IS NULL) OR ([ownedOrLeased] = @Original_ownedOrLeased)) AND ((@IsNull_dnbIndustryCode = 1 AND [dnbIndustryCode] IS NULL) OR ([dnbIndustryCode] = @Original_dnbIndustryCode)) AND ((@IsNull_RelatedIndustries = 1 AND [RelatedIndustries] IS NULL) OR ([RelatedIndustries] = @Original_RelatedIndustries)) AND ((@IsNull_fastFacts = 1 AND [fastFacts] IS NULL) OR ([fastFacts] = @Original_fastFacts)) AND ((@IsNull_CompanyKeyWord = 1 AND [CompanyKeyWord] IS NULL) OR ([CompanyKeyWord] = @Original_CompanyKeyWord)) AND ((@IsNull_LastUpdated = 1 AND [LastUpdated] IS NULL) OR ([LastUpdated] = @Original_LastUpdated)));
SELECT bizDataId, CompanyId, CompanyName, Address1, City, StateOrProvince, PostalCode, Phone, offset, LocationType, Duns, ParentDuns, UltimateParentDuns, Sales, DBA, CountryID, primaryURLs, Description, CompanyType, IndustryName, IndustryDescription, lineOfBusiness, primaryDnBIC, primaryNAICS, primaryUSSIC, naicsCodes, Longitude, Latitutude, WomenOwned, MinorityOwned, ownedOrLeased, dnbIndustryCode, RelatedIndustries, fastFacts, CompanyKeyWord, LastUpdated FROM bizData WHERE (bizDataId = @bizDataId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CompanyId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CompanyId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CompanyName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CompanyName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Address1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Address1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@City" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@StateOrProvince" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="StateOrProvince" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PostalCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PostalCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@offset" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="offset" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@LocationType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="LocationType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Duns" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Duns" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ParentDuns" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ParentDuns" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UltimateParentDuns" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UltimateParentDuns" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Sales" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Sales" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DBA" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DBA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CountryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountryID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@primaryURLs" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="primaryURLs" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CompanyType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CompanyType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@IndustryName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="IndustryName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@IndustryDescription" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="IndustryDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@lineOfBusiness" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="lineOfBusiness" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@primaryDnBIC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="primaryDnBIC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@primaryNAICS" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="primaryNAICS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@primaryUSSIC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="primaryUSSIC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@naicsCodes" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="naicsCodes" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Longitude" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Longitude" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Latitutude" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Latitutude" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@WomenOwned" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="WomenOwned" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@MinorityOwned" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="MinorityOwned" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ownedOrLeased" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ownedOrLeased" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@dnbIndustryCode" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="dnbIndustryCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@RelatedIndustries" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="RelatedIndustries" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@fastFacts" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fastFacts" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CompanyKeyWord" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CompanyKeyWord" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@LastUpdated" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LastUpdated" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_bizDataId" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="bizDataId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CompanyId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CompanyId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CompanyName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CompanyName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Address1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Address1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Address1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Address1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_City" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_City" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StateOrProvince" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StateOrProvince" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_StateOrProvince" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="StateOrProvince" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PostalCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PostalCode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PostalCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PostalCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Phone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Phone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_offset" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="offset" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_offset" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="offset" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LocationType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LocationType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_LocationType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="LocationType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Duns" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Duns" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Duns" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Duns" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ParentDuns" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ParentDuns" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ParentDuns" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ParentDuns" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UltimateParentDuns" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UltimateParentDuns" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UltimateParentDuns" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UltimateParentDuns" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Sales" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Sales" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Sales" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Sales" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DBA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DBA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DBA" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DBA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CountryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountryID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CountryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountryID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_primaryURLs" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="primaryURLs" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_primaryURLs" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="primaryURLs" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Description" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CompanyType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CompanyType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CompanyType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CompanyType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IndustryName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IndustryName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_IndustryName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="IndustryName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IndustryDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IndustryDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_IndustryDescription" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="IndustryDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_lineOfBusiness" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="lineOfBusiness" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_lineOfBusiness" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="lineOfBusiness" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_primaryDnBIC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="primaryDnBIC" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_primaryDnBIC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="primaryDnBIC" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_primaryNAICS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="primaryNAICS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_primaryNAICS" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="primaryNAICS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_primaryUSSIC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="primaryUSSIC" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_primaryUSSIC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="primaryUSSIC" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_naicsCodes" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="naicsCodes" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_naicsCodes" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="naicsCodes" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Longitude" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Longitude" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Longitude" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Longitude" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Latitutude" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Latitutude" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Latitutude" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Latitutude" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_WomenOwned" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WomenOwned" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_WomenOwned" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="WomenOwned" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MinorityOwned" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MinorityOwned" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_MinorityOwned" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="MinorityOwned" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ownedOrLeased" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ownedOrLeased" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ownedOrLeased" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ownedOrLeased" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dnbIndustryCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dnbIndustryCode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_dnbIndustryCode" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="dnbIndustryCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RelatedIndustries" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RelatedIndustries" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_RelatedIndustries" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="RelatedIndustries" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fastFacts" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fastFacts" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_fastFacts" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fastFacts" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CompanyKeyWord" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CompanyKeyWord" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CompanyKeyWord" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CompanyKeyWord" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LastUpdated" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LastUpdated" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_LastUpdated" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LastUpdated" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="bizDataId" ColumnName="bizDataId" DataSourceName="BizName.dbo.bizData" DataTypeServer="bigint" DbType="Int64" Direction="Input" ParameterName="@bizDataId" Precision="0" ProviderType="BigInt" Scale="0" Size="8" SourceColumn="bizDataId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="bizDataId" DataSetColumn="bizDataId" />
              <Mapping SourceColumn="CompanyId" DataSetColumn="CompanyId" />
              <Mapping SourceColumn="CompanyName" DataSetColumn="CompanyName" />
              <Mapping SourceColumn="Address1" DataSetColumn="Address1" />
              <Mapping SourceColumn="City" DataSetColumn="City" />
              <Mapping SourceColumn="StateOrProvince" DataSetColumn="StateOrProvince" />
              <Mapping SourceColumn="PostalCode" DataSetColumn="PostalCode" />
              <Mapping SourceColumn="Phone" DataSetColumn="Phone" />
              <Mapping SourceColumn="offset" DataSetColumn="offset" />
              <Mapping SourceColumn="LocationType" DataSetColumn="LocationType" />
              <Mapping SourceColumn="Duns" DataSetColumn="Duns" />
              <Mapping SourceColumn="ParentDuns" DataSetColumn="ParentDuns" />
              <Mapping SourceColumn="UltimateParentDuns" DataSetColumn="UltimateParentDuns" />
              <Mapping SourceColumn="Sales" DataSetColumn="Sales" />
              <Mapping SourceColumn="DBA" DataSetColumn="DBA" />
              <Mapping SourceColumn="CountryID" DataSetColumn="CountryID" />
              <Mapping SourceColumn="primaryURLs" DataSetColumn="primaryURLs" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
              <Mapping SourceColumn="CompanyType" DataSetColumn="CompanyType" />
              <Mapping SourceColumn="IndustryName" DataSetColumn="IndustryName" />
              <Mapping SourceColumn="IndustryDescription" DataSetColumn="IndustryDescription" />
              <Mapping SourceColumn="lineOfBusiness" DataSetColumn="lineOfBusiness" />
              <Mapping SourceColumn="primaryDnBIC" DataSetColumn="primaryDnBIC" />
              <Mapping SourceColumn="primaryNAICS" DataSetColumn="primaryNAICS" />
              <Mapping SourceColumn="primaryUSSIC" DataSetColumn="primaryUSSIC" />
              <Mapping SourceColumn="naicsCodes" DataSetColumn="naicsCodes" />
              <Mapping SourceColumn="Longitude" DataSetColumn="Longitude" />
              <Mapping SourceColumn="Latitutude" DataSetColumn="Latitutude" />
              <Mapping SourceColumn="WomenOwned" DataSetColumn="WomenOwned" />
              <Mapping SourceColumn="MinorityOwned" DataSetColumn="MinorityOwned" />
              <Mapping SourceColumn="ownedOrLeased" DataSetColumn="ownedOrLeased" />
              <Mapping SourceColumn="dnbIndustryCode" DataSetColumn="dnbIndustryCode" />
              <Mapping SourceColumn="RelatedIndustries" DataSetColumn="RelatedIndustries" />
              <Mapping SourceColumn="fastFacts" DataSetColumn="fastFacts" />
              <Mapping SourceColumn="CompanyKeyWord" DataSetColumn="CompanyKeyWord" />
              <Mapping SourceColumn="LastUpdated" DataSetColumn="LastUpdated" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="dnbTestConnectionString (MySettings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="CheckCompanyId" Modifier="Public" Name="CheckCompanyId" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="CheckCompanyId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     COUNT(*) AS Expr1
FROM         bizData
WHERE     (CompanyId = @Param1)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="CompanyId" DataSourceName="BizName.dbo.bizData" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@Param1" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="CompanyId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="dnbTestConnectionString (MySettings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateBizData" Modifier="Public" Name="UpdateBizData" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="UpdateBizData">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE    bizData
SET              CompanyName = @CompanyName, Address1 = @Address1, City = @City, StateOrProvince = @StateOrProvince, PostalCode = @PostalCode, 
                      Phone = @Phone, offset = @offset, LocationType = @LocationType, Duns = @Duns, ParentDuns = @ParentDuns, 
                      UltimateParentDuns = @UltimateParentDuns, Sales = @Sales, DBA = @DBA, CountryID = @CountryID, primaryURLs = @primaryURLs, 
                      Description = @Description, CompanyType = @CompanyType, IndustryName = @IndustryName, IndustryDescription = @IndustryDescription, 
                      lineOfBusiness = @lineOfBusiness, primaryDnBIC = @primaryDnBIC, primaryNAICS = @primaryNAICS, primaryUSSIC = @primaryUSSIC, 
                      naicsCodes = @naicsCodes, Longitude = @Longitude, Latitutude = @Latitutude, WomenOwned = @WomenOwned, MinorityOwned = @MinorityOwned, 
                      ownedOrLeased = @ownedOrLeased, dnbIndustryCode = @dnbIndustryCode, RelatedIndustries = @RelatedIndustries, fastFacts = @fastFacts, 
                      CompanyKeyWord = @CompanyKeyWord, LastUpdated = @LastUpdated
WHERE     (CompanyId = @Original_CompanyId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="CompanyName" ColumnName="CompanyName" DataSourceName="BizName.dbo.bizData" DataTypeServer="varchar(150)" DbType="AnsiString" Direction="Input" ParameterName="@CompanyName" Precision="0" ProviderType="VarChar" Scale="0" Size="150" SourceColumn="CompanyName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Address1" ColumnName="Address1" DataSourceName="BizName.dbo.bizData" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@Address1" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="Address1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="City" ColumnName="City" DataSourceName="BizName.dbo.bizData" DataTypeServer="varchar(75)" DbType="AnsiString" Direction="Input" ParameterName="@City" Precision="0" ProviderType="VarChar" Scale="0" Size="75" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="StateOrProvince" ColumnName="StateOrProvince" DataSourceName="BizName.dbo.bizData" DataTypeServer="varchar(2)" DbType="AnsiString" Direction="Input" ParameterName="@StateOrProvince" Precision="0" ProviderType="VarChar" Scale="0" Size="2" SourceColumn="StateOrProvince" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="PostalCode" ColumnName="PostalCode" DataSourceName="BizName.dbo.bizData" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@PostalCode" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="PostalCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Phone" ColumnName="Phone" DataSourceName="BizName.dbo.bizData" DataTypeServer="varchar(25)" DbType="AnsiString" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="VarChar" Scale="0" Size="25" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="offset" ColumnName="offset" DataSourceName="BizName.dbo.bizData" DataTypeServer="bigint" DbType="Int64" Direction="Input" ParameterName="@offset" Precision="0" ProviderType="BigInt" Scale="0" Size="8" SourceColumn="offset" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="LocationType" ColumnName="LocationType" DataSourceName="BizName.dbo.bizData" DataTypeServer="varchar(15)" DbType="AnsiString" Direction="Input" ParameterName="@LocationType" Precision="0" ProviderType="VarChar" Scale="0" Size="15" SourceColumn="LocationType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Duns" ColumnName="Duns" DataSourceName="BizName.dbo.bizData" DataTypeServer="varchar(12)" DbType="AnsiString" Direction="Input" ParameterName="@Duns" Precision="0" ProviderType="VarChar" Scale="0" Size="12" SourceColumn="Duns" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="ParentDuns" ColumnName="ParentDuns" DataSourceName="BizName.dbo.bizData" DataTypeServer="varchar(15)" DbType="AnsiString" Direction="Input" ParameterName="@ParentDuns" Precision="0" ProviderType="VarChar" Scale="0" Size="15" SourceColumn="ParentDuns" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="UltimateParentDuns" ColumnName="UltimateParentDuns" DataSourceName="BizName.dbo.bizData" DataTypeServer="varchar(15)" DbType="AnsiString" Direction="Input" ParameterName="@UltimateParentDuns" Precision="0" ProviderType="VarChar" Scale="0" Size="15" SourceColumn="UltimateParentDuns" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Sales" ColumnName="Sales" DataSourceName="BizName.dbo.bizData" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@Sales" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="Sales" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="DBA" ColumnName="DBA" DataSourceName="BizName.dbo.bizData" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@DBA" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="DBA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="CountryID" ColumnName="CountryID" DataSourceName="BizName.dbo.bizData" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CountryID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CountryID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="primaryURLs" ColumnName="primaryURLs" DataSourceName="BizName.dbo.bizData" DataTypeServer="varchar(350)" DbType="AnsiString" Direction="Input" ParameterName="@primaryURLs" Precision="0" ProviderType="VarChar" Scale="0" Size="350" SourceColumn="primaryURLs" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Description" ColumnName="Description" DataSourceName="BizName.dbo.bizData" DataTypeServer="varchar(350)" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="VarChar" Scale="0" Size="350" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="CompanyType" ColumnName="CompanyType" DataSourceName="BizName.dbo.bizData" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@CompanyType" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="CompanyType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="IndustryName" ColumnName="IndustryName" DataSourceName="BizName.dbo.bizData" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@IndustryName" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="IndustryName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="IndustryDescription" ColumnName="IndustryDescription" DataSourceName="BizName.dbo.bizData" DataTypeServer="varchar(150)" DbType="AnsiString" Direction="Input" ParameterName="@IndustryDescription" Precision="0" ProviderType="VarChar" Scale="0" Size="150" SourceColumn="IndustryDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="lineOfBusiness" ColumnName="lineOfBusiness" DataSourceName="BizName.dbo.bizData" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@lineOfBusiness" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="lineOfBusiness" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="primaryDnBIC" ColumnName="primaryDnBIC" DataSourceName="BizName.dbo.bizData" DataTypeServer="nchar(10)" DbType="String" Direction="Input" ParameterName="@primaryDnBIC" Precision="0" ProviderType="NChar" Scale="0" Size="10" SourceColumn="primaryDnBIC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="primaryNAICS" ColumnName="primaryNAICS" DataSourceName="BizName.dbo.bizData" DataTypeServer="nchar(10)" DbType="String" Direction="Input" ParameterName="@primaryNAICS" Precision="0" ProviderType="NChar" Scale="0" Size="10" SourceColumn="primaryNAICS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="primaryUSSIC" ColumnName="primaryUSSIC" DataSourceName="BizName.dbo.bizData" DataTypeServer="varchar(150)" DbType="AnsiString" Direction="Input" ParameterName="@primaryUSSIC" Precision="0" ProviderType="VarChar" Scale="0" Size="150" SourceColumn="primaryUSSIC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="naicsCodes" ColumnName="naicsCodes" DataSourceName="BizName.dbo.bizData" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@naicsCodes" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="naicsCodes" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Longitude" ColumnName="Longitude" DataSourceName="BizName.dbo.bizData" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@Longitude" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="Longitude" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Latitutude" ColumnName="Latitutude" DataSourceName="BizName.dbo.bizData" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@Latitutude" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="Latitutude" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="WomenOwned" ColumnName="WomenOwned" DataSourceName="BizName.dbo.bizData" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@WomenOwned" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="WomenOwned" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="MinorityOwned" ColumnName="MinorityOwned" DataSourceName="BizName.dbo.bizData" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@MinorityOwned" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="MinorityOwned" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="ownedOrLeased" ColumnName="ownedOrLeased" DataSourceName="BizName.dbo.bizData" DataTypeServer="nchar(10)" DbType="String" Direction="Input" ParameterName="@ownedOrLeased" Precision="0" ProviderType="NChar" Scale="0" Size="10" SourceColumn="ownedOrLeased" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="dnbIndustryCode" ColumnName="dnbIndustryCode" DataSourceName="BizName.dbo.bizData" DataTypeServer="nchar(10)" DbType="String" Direction="Input" ParameterName="@dnbIndustryCode" Precision="0" ProviderType="NChar" Scale="0" Size="10" SourceColumn="dnbIndustryCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="RelatedIndustries" ColumnName="RelatedIndustries" DataSourceName="BizName.dbo.bizData" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@RelatedIndustries" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="RelatedIndustries" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="fastFacts" ColumnName="fastFacts" DataSourceName="BizName.dbo.bizData" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@fastFacts" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="fastFacts" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="CompanyKeyWord" ColumnName="CompanyKeyWord" DataSourceName="BizName.dbo.bizData" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@CompanyKeyWord" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="CompanyKeyWord" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="LastUpdated" ColumnName="LastUpdated" DataSourceName="BizName.dbo.bizData" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@LastUpdated" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="LastUpdated" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_CompanyId" ColumnName="CompanyId" DataSourceName="BizName.dbo.bizData" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@Original_CompanyId" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="CompanyId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="BizDataDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="BizDataDataSet" msprop:Generator_UserDSName="BizDataDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="bizData" msprop:Generator_TableClassName="bizDataDataTable" msprop:Generator_TableVarName="tablebizData" msprop:Generator_TablePropName="bizData" msprop:Generator_RowDeletingName="bizDataRowDeleting" msprop:Generator_UserTableName="bizData" msprop:Generator_RowChangingName="bizDataRowChanging" msprop:Generator_RowEvHandlerName="bizDataRowChangeEventHandler" msprop:Generator_RowDeletedName="bizDataRowDeleted" msprop:Generator_RowEvArgName="bizDataRowChangeEvent" msprop:Generator_RowChangedName="bizDataRowChanged" msprop:Generator_RowClassName="bizDataRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="bizDataId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnbizDataId" msprop:Generator_ColumnPropNameInRow="bizDataId" msprop:Generator_ColumnPropNameInTable="bizDataIdColumn" msprop:Generator_UserColumnName="bizDataId" type="xs:long" />
              <xs:element name="CompanyId" msprop:Generator_ColumnVarNameInTable="columnCompanyId" msprop:Generator_ColumnPropNameInRow="CompanyId" msprop:Generator_ColumnPropNameInTable="CompanyIdColumn" msprop:Generator_UserColumnName="CompanyId">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CompanyName" msprop:Generator_ColumnVarNameInTable="columnCompanyName" msprop:Generator_ColumnPropNameInRow="CompanyName" msprop:Generator_ColumnPropNameInTable="CompanyNameColumn" msprop:Generator_UserColumnName="CompanyName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Address1" msprop:Generator_ColumnVarNameInTable="columnAddress1" msprop:Generator_ColumnPropNameInRow="Address1" msprop:Generator_ColumnPropNameInTable="Address1Column" msprop:Generator_UserColumnName="Address1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="City" msprop:Generator_ColumnVarNameInTable="columnCity" msprop:Generator_ColumnPropNameInRow="City" msprop:Generator_ColumnPropNameInTable="CityColumn" msprop:Generator_UserColumnName="City" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="75" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StateOrProvince" msprop:Generator_ColumnVarNameInTable="columnStateOrProvince" msprop:Generator_ColumnPropNameInRow="StateOrProvince" msprop:Generator_ColumnPropNameInTable="StateOrProvinceColumn" msprop:Generator_UserColumnName="StateOrProvince" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PostalCode" msprop:Generator_ColumnVarNameInTable="columnPostalCode" msprop:Generator_ColumnPropNameInRow="PostalCode" msprop:Generator_ColumnPropNameInTable="PostalCodeColumn" msprop:Generator_UserColumnName="PostalCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Phone" msprop:Generator_ColumnVarNameInTable="columnPhone" msprop:Generator_ColumnPropNameInRow="Phone" msprop:Generator_ColumnPropNameInTable="PhoneColumn" msprop:Generator_UserColumnName="Phone" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="offset" msprop:Generator_ColumnVarNameInTable="columnoffset" msprop:Generator_ColumnPropNameInRow="offset" msprop:Generator_ColumnPropNameInTable="offsetColumn" msprop:Generator_UserColumnName="offset" type="xs:long" minOccurs="0" />
              <xs:element name="LocationType" msprop:Generator_ColumnVarNameInTable="columnLocationType" msprop:Generator_ColumnPropNameInRow="LocationType" msprop:Generator_ColumnPropNameInTable="LocationTypeColumn" msprop:Generator_UserColumnName="LocationType" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Duns" msprop:Generator_ColumnVarNameInTable="columnDuns" msprop:Generator_ColumnPropNameInRow="Duns" msprop:Generator_ColumnPropNameInTable="DunsColumn" msprop:Generator_UserColumnName="Duns" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="120" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ParentDuns" msprop:Generator_ColumnVarNameInTable="columnParentDuns" msprop:Generator_ColumnPropNameInRow="ParentDuns" msprop:Generator_ColumnPropNameInTable="ParentDunsColumn" msprop:Generator_UserColumnName="ParentDuns" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UltimateParentDuns" msprop:Generator_ColumnVarNameInTable="columnUltimateParentDuns" msprop:Generator_ColumnPropNameInRow="UltimateParentDuns" msprop:Generator_ColumnPropNameInTable="UltimateParentDunsColumn" msprop:Generator_UserColumnName="UltimateParentDuns" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Sales" msprop:Generator_ColumnVarNameInTable="columnSales" msprop:Generator_ColumnPropNameInRow="Sales" msprop:Generator_ColumnPropNameInTable="SalesColumn" msprop:Generator_UserColumnName="Sales" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DBA" msprop:Generator_ColumnVarNameInTable="columnDBA" msprop:Generator_ColumnPropNameInRow="DBA" msprop:Generator_ColumnPropNameInTable="DBAColumn" msprop:Generator_UserColumnName="DBA" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CountryID" msprop:Generator_ColumnVarNameInTable="columnCountryID" msprop:Generator_ColumnPropNameInRow="CountryID" msprop:Generator_ColumnPropNameInTable="CountryIDColumn" msprop:Generator_UserColumnName="CountryID" type="xs:int" minOccurs="0" />
              <xs:element name="primaryURLs" msprop:Generator_ColumnVarNameInTable="columnprimaryURLs" msprop:Generator_ColumnPropNameInRow="primaryURLs" msprop:Generator_ColumnPropNameInTable="primaryURLsColumn" msprop:Generator_UserColumnName="primaryURLs" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="350" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" msprop:Generator_UserColumnName="Description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="350" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CompanyType" msprop:Generator_ColumnVarNameInTable="columnCompanyType" msprop:Generator_ColumnPropNameInRow="CompanyType" msprop:Generator_ColumnPropNameInTable="CompanyTypeColumn" msprop:Generator_UserColumnName="CompanyType" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IndustryName" msprop:Generator_ColumnVarNameInTable="columnIndustryName" msprop:Generator_ColumnPropNameInRow="IndustryName" msprop:Generator_ColumnPropNameInTable="IndustryNameColumn" msprop:Generator_UserColumnName="IndustryName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IndustryDescription" msprop:Generator_ColumnVarNameInTable="columnIndustryDescription" msprop:Generator_ColumnPropNameInRow="IndustryDescription" msprop:Generator_ColumnPropNameInTable="IndustryDescriptionColumn" msprop:Generator_UserColumnName="IndustryDescription" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="lineOfBusiness" msprop:Generator_ColumnVarNameInTable="columnlineOfBusiness" msprop:Generator_ColumnPropNameInRow="lineOfBusiness" msprop:Generator_ColumnPropNameInTable="lineOfBusinessColumn" msprop:Generator_UserColumnName="lineOfBusiness" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="primaryDnBIC" msprop:Generator_ColumnVarNameInTable="columnprimaryDnBIC" msprop:Generator_ColumnPropNameInRow="primaryDnBIC" msprop:Generator_ColumnPropNameInTable="primaryDnBICColumn" msprop:Generator_UserColumnName="primaryDnBIC" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="primaryNAICS" msprop:Generator_ColumnVarNameInTable="columnprimaryNAICS" msprop:Generator_ColumnPropNameInRow="primaryNAICS" msprop:Generator_ColumnPropNameInTable="primaryNAICSColumn" msprop:Generator_UserColumnName="primaryNAICS" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="primaryUSSIC" msprop:Generator_ColumnVarNameInTable="columnprimaryUSSIC" msprop:Generator_ColumnPropNameInRow="primaryUSSIC" msprop:Generator_ColumnPropNameInTable="primaryUSSICColumn" msprop:Generator_UserColumnName="primaryUSSIC" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="naicsCodes" msprop:Generator_ColumnVarNameInTable="columnnaicsCodes" msprop:Generator_ColumnPropNameInRow="naicsCodes" msprop:Generator_ColumnPropNameInTable="naicsCodesColumn" msprop:Generator_UserColumnName="naicsCodes" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Longitude" msprop:Generator_ColumnVarNameInTable="columnLongitude" msprop:Generator_ColumnPropNameInRow="Longitude" msprop:Generator_ColumnPropNameInTable="LongitudeColumn" msprop:Generator_UserColumnName="Longitude" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Latitutude" msprop:Generator_ColumnVarNameInTable="columnLatitutude" msprop:Generator_ColumnPropNameInRow="Latitutude" msprop:Generator_ColumnPropNameInTable="LatitutudeColumn" msprop:Generator_UserColumnName="Latitutude" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="WomenOwned" msprop:Generator_ColumnVarNameInTable="columnWomenOwned" msprop:Generator_ColumnPropNameInRow="WomenOwned" msprop:Generator_ColumnPropNameInTable="WomenOwnedColumn" msprop:Generator_UserColumnName="WomenOwned" type="xs:boolean" minOccurs="0" />
              <xs:element name="MinorityOwned" msprop:Generator_ColumnVarNameInTable="columnMinorityOwned" msprop:Generator_ColumnPropNameInRow="MinorityOwned" msprop:Generator_ColumnPropNameInTable="MinorityOwnedColumn" msprop:Generator_UserColumnName="MinorityOwned" type="xs:boolean" minOccurs="0" />
              <xs:element name="ownedOrLeased" msprop:Generator_ColumnVarNameInTable="columnownedOrLeased" msprop:Generator_ColumnPropNameInRow="ownedOrLeased" msprop:Generator_ColumnPropNameInTable="ownedOrLeasedColumn" msprop:Generator_UserColumnName="ownedOrLeased" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dnbIndustryCode" msprop:Generator_ColumnVarNameInTable="columndnbIndustryCode" msprop:Generator_ColumnPropNameInRow="dnbIndustryCode" msprop:Generator_ColumnPropNameInTable="dnbIndustryCodeColumn" msprop:Generator_UserColumnName="dnbIndustryCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RelatedIndustries" msprop:Generator_ColumnVarNameInTable="columnRelatedIndustries" msprop:Generator_ColumnPropNameInRow="RelatedIndustries" msprop:Generator_ColumnPropNameInTable="RelatedIndustriesColumn" msprop:Generator_UserColumnName="RelatedIndustries" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="fastFacts" msprop:Generator_ColumnVarNameInTable="columnfastFacts" msprop:Generator_ColumnPropNameInRow="fastFacts" msprop:Generator_ColumnPropNameInTable="fastFactsColumn" msprop:Generator_UserColumnName="fastFacts" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CompanyKeyWord" msprop:Generator_ColumnVarNameInTable="columnCompanyKeyWord" msprop:Generator_ColumnPropNameInRow="CompanyKeyWord" msprop:Generator_ColumnPropNameInTable="CompanyKeyWordColumn" msprop:Generator_UserColumnName="CompanyKeyWord" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LastUpdated" msprop:Generator_ColumnVarNameInTable="columnLastUpdated" msprop:Generator_ColumnPropNameInRow="LastUpdated" msprop:Generator_ColumnPropNameInTable="LastUpdatedColumn" msprop:Generator_UserColumnName="LastUpdated" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:bizData" />
      <xs:field xpath="mstns:bizDataId" />
    </xs:unique>
  </xs:element>
</xs:schema>